64 BI introductory
BI introductory Excel · CSV · SQL data Power BI Desktop and Power BI Service with and, Power Query · DAX · up to with practical work type BI education with.
0. Purpose and ultimate goal
BI introductory education of objective learners Power BI Desktop, Power Query, DAX, Power BI Service using work data organization and, KPI focused of visualization report and type creation · sharing. · · · of BI, Microsoft Power BI course, company type data analysis education of using practice · project focused with operation.
Referenced professional training patterns
- Power BI course of data, Power Query, relationship, DAX
- BI of practical work data based KPI design, creation, report presentation
- Company education of Power BI Service, sharing, with, · operation management
- Data analysis course of Excel · SQL · CSV data and
Introductory · 1 Day
Introductory 1 day BI introductory curriculum
Power BI Desktop of and basic visualization understanding.
:format(webp)/https://static-sg.zacdn.com/p/biotherm-3872-6715651-1.jpg)
:format(webp)/https://static-sg.zacdn.com/p/biotherm-3872-6715651-2.jpg)
:format(webp)/https://static-sg.zacdn.com/p/biotherm-5356-0641621-2.jpg)
| Category | Details | Practice methods |
|---|---|---|
| Objective 1 | Power BI of BI report creation understanding. | Excel · CSV data Power BI Desktop with field, visualization, filter, practice. Power Query, Report View, Data View, Model View of role comparison and report creation order with organize. |
| Objective 2 | Basic visualization and creation. | Chart, chart,,,, chart chart of Category. , filter, filter application using by with data create. |
| Objective 3 | Work complete. | Sales · educationoperation data with KPI, by, local community by comparison, by. Power BI Desktop file(.pbix) saving and PDF · PowerPoint with result sharing. |
| Platforms | Power BI Desktop, Excel 365, CSV, Power Query, PowerPoint, OneDrive |
|---|---|
| Instructor profile | Power BI Desktop practical work report creation, Excel data organization, basic BI education 2years or more |
| Target learners | BI introductory,, data, job seeker, small business owner |
| Duration | 4-6 hours |
| Materials | Windows, Power BI Desktop, Excel file, CSV, Microsoft account |
| Deliverables | Basic Power BI report, KPI 1, PDF result |
| Assessment method | Data 20%, chart creation 35%, filter 20%, completion 15%, participation 10% |
Beginner · 3 Days
Beginner 3 days BI introductory curriculum
Data organization, relationship, DAX basic using work type creation.
| Category | Details | Practice methods |
|---|---|---|
| Objective 1 | Power Query with data. | , data,,,, filter practice. Excel · CSV · data with query step-by-step application. |
| Objective 2 | Basic data. | And Category and · · local community relationship create. Relationship, basic,, sorting settings using improvement. |
| Objective 3 | DAX basic writing. | SUM, COUNTROWS, DISTINCTCOUNT, DIVIDE, CALCULATE using sales,,, create. To DAX application and filter to course. |
| Platforms | Power BI Desktop, Power Query, DAX, Excel 365, CSV, Microsoft Learn data |
|---|---|
| Instructor profile | Power Query, relationship, DAX basic, practical work education 3years or more |
| Target learners | Excel experience, data practitioner, · marketing ·, job seeker |
| Duration | 12-18 hours |
| Materials | Windows, Power BI Desktop, Excel 365, sales data, practice |
| Deliverables | Query, relationship, DAX, 2 work |
| Assessment method | Power Query 25%, 25%, DAX 25%, report completion also 15%, presentation 10% |
Beginner · 1 Week
Beginner 1 week BI introductory curriculum
Power BI report organization of to design and up to experience.
| Category | Details | Practice methods |
|---|---|---|
| Objective 1 | KPI focused report design. | ,, KPI, table, filter, report with writing. Sales · · educationoperation data in by and visualization with design. |
| Objective 2 | Type report creation. | ,, bookmark,, using type report create. , N filter,, theme application using practical work report quality. |
| Objective 3 | Power BI Service sharing understanding. | Power BI Service of,,, app practice focused with organize. Data with,, sharing,, of operation writing. |
| Platforms | Power BI Desktop, Power BI Service, DAX, Power Query, Excel, SharePoint/OneDrive |
|---|---|
| Instructor profile | Power BI report design, DAX practical work, Power BI Service, data management education 3years or more |
| Target learners | BI, team, practical work, PM, marketing · analysis |
| Duration | 20-30 hours |
| Materials | Power BI account, organization type data, Microsoft account, report |
| Deliverables | KPI, type Power BI report, · operation |
| Assessment method | 20%, DAX · 25%, 25%, understanding 15%, presentation 15% |
Intermediate · 4 Weeks
Intermediate 4 weeks BI introductory curriculum
And organization operation Power BI project type.
| Category | Details | Practice methods |
|---|---|---|
| Objective 1 | Practical work type data. | ,,, role by. Power Query,,,, using create. |
| Objective 2 | DAX analysis. | YTD, MoM, YoY,,, objective difference, table DAX with writing. CALCULATE, FILTER, ALL, SAMEPERIODLASTYEAR, TOTALYTD of application result visualization with. |
| Objective 3 | Report operation system design. | Data with,,, also, RLS practical work with organize. Report,, management, feedback procedure operation document with writing. |
| Platforms | Power BI Desktop, Power BI Service, DAX Studio, Excel Power Query, SQL Server, SharePoint/OneDrive |
|---|---|
| Instructor profile | Power BI, advanced DAX, Service operation, RLS · · project experience 4years or more |
| Target learners | Power BI beginner, organization, data analysis practitioner, work |
| Duration | 40-60 hours |
| Materials | Power BI Pro or assessment account, organization type data, SQL/Excel data, operationdocument |
| Deliverables | Practical work data, advanced DAX, operation type, operation document |
| Assessment method | 25%, DAX 30%, operation design 20%, quality 15%, presentation 10% |
Advanced · 8 Weeks
Advanced 8 weeks BI introductory curriculum
Power BI based BI project perform and portfolio complete.
| Category | Details | Practice methods |
|---|---|---|
| Objective 1 | BI project and data design. | Interview, KPI, data, security, with project plan to organize. Excel · CSV · SQL · data using Power Query design and data create. |
| Objective 2 | Organization Power BI. | Report,, role by, RLS,, improvement report create. Power BI Service in, app, with,, settings and operation scenario. |
| Objective 3 | Education · Deliverables creation. | Beginner practice data, step-by-step, DAX problem, assignment, assessment rubric creation. Portfolio presentation in problem, data, core, operation plan, improvement. |
| Platforms | Power BI Desktop, Power BI Service, Power Query, DAX, SQL Server/PostgreSQL, Excel, SharePoint, Teams, Notion |
|---|---|
| Instructor profile | Power BI, BI, DAX, data, instructor experience 5years or more |
| Target learners | BI instructor course, data analysis, practical work, company Power BI |
| Duration | 80-120 hours |
| Materials | Windows, Power BI Pro account, SQL DB, project data, presentation deck tools |
| Deliverables | BI project plan, Power BI portfolio, operation manual, materials, assessment rubric |
| Assessment method | Project 20%, 35%, operation settings 20%, educationmaterials 15%, presentation 10% |